package com.cn.esermis.datawarn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cn.esermis.datawarn.entity.WaterHourRecord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;
@Mapper
public interface CountWaterChargeMapper extends BaseMapper<WaterHourRecord> {
    @Select(value = "select ${zd} from water_monitor_hour_record where mn = #{mn} and factor = #{factor} and data_time in (#{time1},#{time2},#{time3},#{time4},#{time5}) ")
    List<BigDecimal> airSixHour(@Param("zd") String zd ,@Param("mn") String mn , @Param("factor") String factor, @Param("time1") String time1, @Param("time2") String time2, @Param("time3") String time3, @Param("time4") String time4, @Param("time5") String time5);
}
